Overview

Dataset info

Number of variables81
Number of observations5499
Missing cells57440 (12.9%)
Duplicate rows0 (0.0%)
Total size in memory3.4 MiB
Average record size in memory648.0 B

Variables types

Numeric10
Categorical38
Boolean17
Date0
URL0
Text (Unique)0
Rejected16
Unsupported0

Warnings

AdvanceAmount has constant value "0.0" Rejected
AdvanceReject(Y/N) has 368 (6.7%) missing values Missing
AmountClaim has 339 (6.2%) zeros Zeros
AOEmailAddress has a high cardinality: 324 distinct values Warning
AOEmailAddress has 377 (6.9%) missing values Missing
AwaitingStatus has constant value "nan" Rejected
CancelledDate has 5489 (99.8%) missing values Missing
Changes_Needed_(Y/N) has 4555 (82.8%) missing values Missing
Comments has a high cardinality: 348 distinct values Warning
Comments has 4557 (82.9%) missing values Missing
ConstructiveTravelFlag has 368 (6.7%) missing values Missing
Corrected_Date has a high cardinality: 74 distinct values Warning
Corrected_Date has 5375 (97.7%) missing values Missing
CurrentVersionCompletedDate has a high cardinality: 297 distinct values Warning
DateofCurrentStatus has a high cardinality: 303 distinct values Warning
DCSSuborganization has 3511 (63.8%) missing values Missing
DepartureDate has a high cardinality: 462 distinct values Warning
DocumentCreateDate has a high cardinality: 382 distinct values Warning
DocumentName has a high cardinality: 5013 distinct values Warning
DTAIDEmailAddress has 368 (6.7%) missing values Missing
Error_Category has constant value "nan" Rejected
ExpensesbyLOA has 433 (7.9%) zeros Zeros
FullName has a high cardinality: 1154 distinct values Warning
ImproperPaymentCorrections is highly skewed (γ1 = 65.72940543) Skewed
ImproperPaymentCorrections has 5290 (96.2%) zeros Zeros
IncludesSPP(Y/N) has constant value "N" Rejected
LastAOApprovedDate has a high cardinality: 297 distinct values Warning
LOA10by20 has a high cardinality: 548 distinct values Warning
LOALabel has a high cardinality: 547 distinct values Warning
Location/Destination(firstonly) has a high cardinality: 498 distinct values Warning
Location/Destination(firstonly) has 529 (9.6%) missing values Missing
Month_Rank is highly correlated with df_index (ρ = 0.9899008813) Rejected
Overpayments(Debts)* is highly skewed (γ1 = 22.12386129) Skewed
Overpayments(Debts)* has 5332 (97.0%) zeros Zeros
Overpayments_(Debts)* is highly correlated with Overpayments(Debts)* (ρ = 1) Rejected
PNRRecordLocator(allshown) has a high cardinality: 3267 distinct values Warning
PNRRecordLocator(allshown) has 1729 (31.4%) missing values Missing
Reference has a high cardinality: 111 distinct values Warning
Reference has 5222 (95.0%) missing values Missing
ReturnDate has a high cardinality: 467 distinct values Warning
ReviewedVouchers is highly correlated with Reviewed_Record (ρ = 1) Rejected
SDN(representativeSDNfordoctype) has a high cardinality: 4942 distinct values Warning
Sent_Date has 5283 (96.1%) missing values Missing
SignedDate has a high cardinality: 355 distinct values Warning
SpecialCircumstancesTripType has constant value "nan" Rejected
SPPReject(Y/N) has 368 (6.7%) missing values Missing
SSN has a high cardinality: 1077 distinct values Warning
SSN has 368 (6.7%) missing values Missing
TANum has a high cardinality: 4887 distinct values Warning
TotalCP-C/CR-CAmount is highly skewed (γ1 = 70.0678505) Skewed
TotalCP-C/CR-CAmount has 5478 (99.6%) zeros Zeros
TotalCP/CRAmount has 2891 (52.6%) zeros Zeros
TotalInputError is highly correlated with InputError (ρ = 1) Rejected
TotalMiscellaneous is highly correlated with Miscellaneous (ρ = 1) Rejected
TotalMissingInvalidReceiptDocumentation is highly correlated with Missing_InvalidReceipt_Documentation (ρ = 1) Rejected
TotalReceiptDoesNotMatchClaim is highly correlated with Receiptdoesnotmatchclaim (ρ = 1) Rejected
TotalRegulationUnauthorized is highly correlated with Regulation_Unauthorized (ρ = 1) Rejected
TotalReimbursableExpenses is highly correlated with AmountClaim (ρ = 0.9993386598) Rejected
TotalTripExpenses is highly correlated with TotalReimbursableExpenses (ρ = 0.9988470133) Rejected
Travel_Location has a high cardinality: 498 distinct values Warning
Travel_Location has 529 (9.6%) missing values Missing
TravelerEmailAddress has a high cardinality: 1152 distinct values Warning
TravelerEmailAddress has 368 (6.7%) missing values Missing
TravelerFirstName has a high cardinality: 616 distinct values Warning
TravelerLastName has a high cardinality: 1005 distinct values Warning
TripDescription has a high cardinality: 3510 distinct values Warning
TripDescription has 1194 (21.7%) missing values Missing
TripPurpose has 166 (3.0%) missing values Missing
TripType has 166 (3.0%) missing values Missing
Underpayments(Credits)* is highly skewed (γ1 = 51.72512377) Skewed
Underpayments(Credits)* has 5428 (98.7%) zeros Zeros
Underpayments_(Credits)* is highly correlated with Underpayments(Credits)* (ρ = 1) Rejected

Variables

Actuals(Y/N)
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
4855
Y
 
644
ValueCountFrequency (%) 
N 4855 88.3%
 
Y 644 11.7%
 

AdvanceAmount
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

AdvanceReject(Y/N)
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)6.7%
Missing (n)368
N
5131
(Missing)
 
368
ValueCountFrequency (%) 
N 5131 93.3%
 
(Missing) 368 6.7%
 
Max length3
Mean length1.133842517
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Advisory
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5390
1
 
109
ValueCountFrequency (%) 
0 5390 98.0%
 
1 109 2.0%
 

AmountClaim
Numeric

Distinct count3591
Unique (%)65.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2016.091331
Minimum0
Maximum56739.73
Zeros (%)6.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q1255
Median904.36
Q32097.09
95-th percentile7696.943
Maximum56739.73
Range56739.73
Interquartile range1842.09

Descriptive statistics

Standard deviation3804.246035
Coef of variation1.886941319
Kurtosis52.56479669
Mean2016.091331
MAD1998.847841
Skewness5.976357566
Sum11086486.23
Variance14472287.9
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 1.550000e+00 4.050000e+00 7.425000e+00 9.030000e+00 ... 1.108554e+04 1.551254e+04 2.210496e+04 4.390844e+04 5.673973e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 339 6.2%
 
91.5 114 2.1%
 
307.5 52 0.9%
 
161.5 41 0.7%
 
176.5 38 0.7%
 
8.35 37 0.7%
 
157.5 30 0.5%
 
211.5 26 0.5%
 
320 25 0.5%
 
3.1 25 0.5%
 
Other values (3581) 4772 86.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 339 6.2%
 
3.1 25 0.5%
 
5 2 < 0.1%
 
5.25 1 < 0.1%
 
6.47 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
56739.73 1 < 0.1%
 
53760.22 1 < 0.1%
 
43908.57 1 < 0.1%
 
43908.31 2 < 0.1%
 
42330.84 3 0.1%
 

AOEmailAddress
Categorical

Distinct count324
Unique (%)5.9%
Missing (%)6.9%
Missing (n)377
MICHAEL.J.MCGONAGLE2.CIV@MAIL.MIL
 
634
jason.focht@us.af.mil
 
260
darrell.l.williams58.civ@mail.mil
 
192
Other values (320)
4036
(Missing)
 
377
ValueCountFrequency (%) 
MICHAEL.J.MCGONAGLE2.CIV@MAIL.MIL 634 11.5%
 
jason.focht@us.af.mil 260 4.7%
 
darrell.l.williams58.civ@mail.mil 192 3.5%
 
john.l.huff8.mil@mail.mil 149 2.7%
 
michael.a.hansen12.civ@mail.mil 122 2.2%
 
Vincent.Cassano@me.navy.mil 109 2.0%
 
john.a.syc.civ@mail.mil 98 1.8%
 
omar.correa@airtermnorva.navy.mil 96 1.7%
 
LASHON.R.RUSSELL@NAVY.MIL 95 1.7%
 
brian.j.muller.civ@mail.mil 91 1.7%
 
Other values (313) 3276 59.6%
 
(Missing) 377 6.9%
 
Max length39
Mean length26.17966903
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

AutoKey
Numeric

Distinct count5499
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean65519.00182
Minimum58303
Maximum69795
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum58303
5-th percentile62778.9
Q163878.5
Median65253
Q366627.5
95-th percentile68831.1
Maximum69795
Range11492
Interquartile range2749

Descriptive statistics

Standard deviation2006.940967
Coef of variation0.0306314338
Kurtosis-0.792993044
Mean65519.00182
MAD1667.956168
Skewness0.3715240928
Sum360288991
Variance4027812.045
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[58303. 62526.5 66744.5 67850.5 68917.5 69460.5 69560.5 69710.5 69795. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
65031 1 < 0.1%
 
67928 1 < 0.1%
 
67874 1 < 0.1%
 
65805 1 < 0.1%
 
65919 1 < 0.1%
 
67927 1 < 0.1%
 
65148 1 < 0.1%
 
66026 1 < 0.1%
 
64110 1 < 0.1%
 
65511 1 < 0.1%
 
Other values (5489) 5489 99.8%
 

Minimum 5 values

ValueCountFrequency (%) 
58303 1 < 0.1%
 
58852 1 < 0.1%
 
58853 1 < 0.1%
 
58854 1 < 0.1%
 
58938 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
69795 1 < 0.1%
 
69794 1 < 0.1%
 
69793 1 < 0.1%
 
69792 1 < 0.1%
 
69791 1 < 0.1%
 

AwaitingStatus
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

CancelledDate
Categorical

Distinct count11
Unique (%)0.2%
Missing (%)99.8%
Missing (n)5489
43619
 
1
8/13/2019
 
1
2/10/2020
 
1
Other values (7)
 
7
(Missing)
5489
ValueCountFrequency (%) 
43619 1 < 0.1%
 
8/13/2019 1 < 0.1%
 
2/10/2020 1 < 0.1%
 
11/18/2019 1 < 0.1%
 
9/13/2019 1 < 0.1%
 
7/22/2019 1 < 0.1%
 
7/24/2019 1 < 0.1%
 
8/15/2019 1 < 0.1%
 
3/24/2020 1 < 0.1%
 
1/10/2020 1 < 0.1%
 
(Missing) 5489 99.8%
 
Max length10
Mean length3.010365521
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Changes_Needed_(Y/N)
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)82.8%
Missing (n)4555
No
 
725
Yes
 
219
(Missing)
4555
ValueCountFrequency (%) 
No 725 13.2%
 
Yes 219 4.0%
 
(Missing) 4555 82.8%
 

Comments
Categorical

Distinct count348
Unique (%)6.3%
Missing (%)82.9%
Missing (n)4557
Okay
 
584
This voucher being audited as it overlaps with TANUM 28IXFD, changed Month-End Date from 5-31-2019 so it will print on the July PPR report. Because this is a TDY from a TDY location the first and last day of this is considered interim travel days and should be paid at full M&IE rate not as 75% travel day. Traveler due additional $28. Per JTR 020303 Table 2-16, Lodging claim for this TDY should be claimed on the per diem screen, lodging retained at the original TDY location is claimed under expenses as Dual Lodging. Unable to correct errors as traveler is no longer assigned to USTRANSCOM. TSgt Patrick Weaver - 20191018
 
3
Advisory: This voucher was T-entered by Kayla Georgiafandis. The DD 1351-2 attached was printed from DTS after the voucher was created. If the NDEA creates the voucher without being given a signed DD 1351-2 telling them what to claim on the voucher, the Traveler needs to review the voucher and personnally sign it using their CAC. In order for an NDEA to use T-enter (sign the voucher) capability the following rules MUST be followed: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the capability removed. The procedures outlined above and in the NDEA training keeps the NDEA from any pecuniary liability for an improper payment.
 
2
Other values (344)
 
353
(Missing)
4557
ValueCountFrequency (%) 
Okay 584 10.6%
 
This voucher being audited as it overlaps with TANUM 28IXFD, changed Month-End Date from 5-31-2019 so it will print on the July PPR report. Because this is a TDY from a TDY location the first and last day of this is considered interim travel days and should be paid at full M&IE rate not as 75% travel day. Traveler due additional $28. Per JTR 020303 Table 2-16, Lodging claim for this TDY should be claimed on the per diem screen, lodging retained at the original TDY location is claimed under expenses as Dual Lodging. Unable to correct errors as traveler is no longer assigned to USTRANSCOM. TSgt Patrick Weaver - 20191018 3 0.1%
 
Advisory: This voucher was T-entered by Kayla Georgiafandis. The DD 1351-2 attached was printed from DTS after the voucher was created. If the NDEA creates the voucher without being given a signed DD 1351-2 telling them what to claim on the voucher, the Traveler needs to review the voucher and personnally sign it using their CAC. In order for an NDEA to use T-enter (sign the voucher) capability the following rules MUST be followed: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the capability removed. The procedures outlined above and in the NDEA training keeps the NDEA from any pecuniary liability for an improper payment. 2 < 0.1%
 
Advisory: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it prior to it being completed in DTS. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) This was improperly T-entered by Marrisa Myatt. This is the 3rd month she was found to not be following the Dod FMR Regulations. 2 < 0.1%
 
This voucher was T-entered by Giselle Murrell. There is no DD 1351-2 submitted by and signed by the traveler attached. Before a Non-DTS Entry Agent (NDEA) can T-ENTER a voucher, the traveler must provide the NDEA with a signed, manually-prepared DD Form 1351-2 telling them what expenses to claim on the voucher. According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the T-enter capability removed. The procedures outlined above, and in the NDEA training, keep the NDEA from any pecuniary liability for an improper payment. Please have traveler provide a completed and signed DD 1351-2 and attach it. 2 < 0.1%
 
Advisory: Traveler was charged $100 for lodging on the day of arrival but only claimed $90 may be due additional $10 if they choose to amend. 2 < 0.1%
 
Okay - 12 hrs or less 2 < 0.1%
 
Advisory: Laundry is covered by the daily incidental paid the traveler and is not a reimbursable item. No change required as it is under $10 and would be written off. 2 < 0.1%
 
Advisory: Per DoD FMR vol 9 Ch 8 080401G -To receive proper reimbursement, the traveler must report the following information on their travel claim: The amount of the expense in foreign currency; the exchange rate on the day the item was purchased in cash, or, the exchange rate at which the credit card was billed if paid with a credit card; and the bank commission(s) charged for conversion of U.S. dollars to foreign currency. The traveler must show the rates of conversion and the commission(s) charged. If the traveler does not show the conversion rate(s), the activity settling the claim must use an appropriate exchange rate for the date the expense was paid 2 < 0.1%
 
Advisory: Was traveler's business conducted in Belleville or at Scott AFB? If Scott AFB that should have been the TDY location used, which would require a Non-A to stay off base. Without a Non-A traveler should have been limited to the $105 rate for lodging on base. 2 < 0.1%
 
Other values (337) 339 6.2%
 
(Missing) 4557 82.9%
 
Max length3409
Mean length36.08346972
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

ConstructiveTravelFlag
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)6.7%
Missing (n)368
N
5089
Y
 
42
(Missing)
 
368
ValueCountFrequency (%) 
N 5089 92.5%
 
Y 42 0.8%
 
(Missing) 368 6.7%
 

Corrected_Date
Categorical

Distinct count74
Unique (%)1.3%
Missing (%)97.7%
Missing (n)5375
10/18/19
 
20
11/4/19
 
5
4/27/20
 
4
Other values (70)
 
95
(Missing)
5375
ValueCountFrequency (%) 
10/18/19 20 0.4%
 
11/4/19 5 0.1%
 
4/27/20 4 0.1%
 
3/13/20 3 0.1%
 
3/11/20 3 0.1%
 
12/10/19 3 0.1%
 
1/22/20 3 0.1%
 
4/20/20 3 0.1%
 
9/18/19 3 0.1%
 
8/16/19 2 < 0.1%
 
Other values (63) 75 1.4%
 
(Missing) 5375 97.7%
 
Max length8
Mean length3.093289689
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

CorrectedVouchers
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5376
1
 
123
ValueCountFrequency (%) 
0 5376 97.8%
 
1 123 2.2%
 

CurrentStatus
Categorical

Distinct count19
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
ARCHIVE IMAGE ACCEPT
2256
ARCHIVE ACCEPTED
2208
OBLIG SUBMITTED
 
260
Other values (16)
775
ValueCountFrequency (%) 
ARCHIVE IMAGE ACCEPT 2256 41.0%
 
ARCHIVE ACCEPTED 2208 40.2%
 
OBLIG SUBMITTED 260 4.7%
 
POS ACK RECEIVED 234 4.3%
 
VOUCHER SUBMITTED 211 3.8%
 
ARCHIVE SUBMITTED 127 2.3%
 
REJECT 54 1.0%
 
DUE PROCESS SERVED 44 0.8%
 
ARCHIVE IMAGE SUBMIT 33 0.6%
 
PAID 22 0.4%
 
Other values (9) 50 0.9%
 
Max length20
Mean length17.54373522
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

CurrentVersionCompletedDate
Categorical

Distinct count297
Unique (%)5.4%
Missing (%)0.2%
Missing (n)10
12/2/19
 
83
7/3/19
 
62
2/10/20
 
55
Other values (293)
5289
ValueCountFrequency (%) 
12/2/19 83 1.5%
 
7/3/19 62 1.1%
 
2/10/20 55 1.0%
 
12/4/19 53 1.0%
 
7/22/19 45 0.8%
 
9/23/19 45 0.8%
 
12/18/19 45 0.8%
 
12/3/19 45 0.8%
 
2/3/20 44 0.8%
 
9/16/19 43 0.8%
 
Other values (286) 4969 90.4%
 
Max length8
Mean length6.98108747
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

DateofCurrentStatus
Categorical

Distinct count303
Unique (%)5.5%
Missing (%)0.0%
Missing (n)0
12/31/19
 
102
12/28/19
 
100
12/30/19
 
99
Other values (300)
5198
ValueCountFrequency (%) 
12/31/19 102 1.9%
 
12/28/19 100 1.8%
 
12/30/19 99 1.8%
 
12/29/19 92 1.7%
 
2/20/20 86 1.6%
 
2/22/20 81 1.5%
 
11/27/19 78 1.4%
 
1/1/20 73 1.3%
 
10/9/19 69 1.3%
 
10/12/19 67 1.2%
 
Other values (293) 4652 84.6%
 
Max length8
Mean length7.054737225
Min length6
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

DCSSuborganization
Categorical

Distinct count19
Unique (%)0.3%
Missing (%)63.8%
Missing (n)3511
BA
 
364
RS
 
251
SG
 
175
Other values (15)
1198
(Missing)
3511
ValueCountFrequency (%) 
BA 364 6.6%
 
RS 251 4.6%
 
SG 175 3.2%
 
BH 160 2.9%
 
JA 157 2.9%
 
LV 131 2.4%
 
NF 123 2.2%
 
TV 119 2.2%
 
SN 98 1.8%
 
YO 75 1.4%
 
Other values (8) 335 6.1%
 
(Missing) 3511 63.8%
 
Max length3
Mean length2.638479724
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

DepartureDate
Categorical

Distinct count462
Unique (%)8.4%
Missing (%)0.0%
Missing (n)0
9/16/19
 
59
10/1/19
 
59
12/9/19
 
57
Other values (459)
5324
ValueCountFrequency (%) 
9/16/19 59 1.1%
 
10/1/19 59 1.1%
 
12/9/19 57 1.0%
 
2/24/20 51 0.9%
 
11/12/19 51 0.9%
 
5/28/19 49 0.9%
 
2/10/20 47 0.9%
 
9/22/19 46 0.8%
 
10/7/19 46 0.8%
 
8/12/19 46 0.8%
 
Other values (452) 4988 90.7%
 
Max length8
Mean length6.939443535
Min length6
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

df_index
Numeric

Distinct count5499
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3451.171849
Minimum0
Maximum7132
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile377.9
Q11650.5
Median3352
Q35241.5
95-th percentile6741.1
Maximum7132
Range7132
Interquartile range3591

Descriptive statistics

Standard deviation2062.893212
Coef of variation0.5977370302
Kurtosis-1.219564481
Mean3451.171849
MAD1794.976145
Skewness0.1018863934
Sum18977994
Variance4255528.404
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 239. 280.5 2964.5 3028.5 ... 3985.5 4086.5 5633.5 5732.5 7132. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
4691 1 < 0.1%
 
2632 1 < 0.1%
 
585 1 < 0.1%
 
6730 1 < 0.1%
 
2636 1 < 0.1%
 
6734 1 < 0.1%
 
2640 1 < 0.1%
 
593 1 < 0.1%
 
6738 1 < 0.1%
 
Other values (5489) 5489 99.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 
5 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7132 1 < 0.1%
 
7131 1 < 0.1%
 
7130 1 < 0.1%
 
7129 1 < 0.1%
 
7128 1 < 0.1%
 

Directorate
Categorical

Distinct count14
Unique (%)0.3%
Missing (%)0.1%
Missing (n)4
TCJ3DCS
1988
JECC
1238
TCJ3
576
Other values (10)
1693
ValueCountFrequency (%) 
TCJ3DCS 1988 36.2%
 
JECC 1238 22.5%
 
TCJ3 576 10.5%
 
TCJ5 533 9.7%
 
TCCC 399 7.3%
 
TCSG 162 2.9%
 
TCAQ 145 2.6%
 
TCJ6 141 2.6%
 
TCJ8 139 2.5%
 
TCJ1 84 1.5%
 
Other values (3) 90 1.6%
 
Max length7
Mean length5.083833424
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

DocumentCreateDate
Categorical

Distinct count382
Unique (%)6.9%
Missing (%)0.0%
Missing (n)0
11/25/19
 
62
2/3/20
 
54
3/9/20
 
54
Other values (379)
5329
ValueCountFrequency (%) 
11/25/19 62 1.1%
 
2/3/20 54 1.0%
 
3/9/20 54 1.0%
 
9/30/19 53 1.0%
 
12/18/19 52 0.9%
 
3/2/20 47 0.9%
 
1/21/20 46 0.8%
 
9/16/19 45 0.8%
 
11/26/19 45 0.8%
 
11/22/19 43 0.8%
 
Other values (372) 4998 90.9%
 
Max length8
Mean length6.999818149
Min length6
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

DocumentName
Categorical

Distinct count5013
Unique (%)91.2%
Missing (%)0.0%
Missing (n)0
SLPOPEARMYAIR081619_V01
 
6
SLSTUTTGARTDE111219_V01
 
6
SLROBINSAFBGA080819_V01
 
6
Other values (5010)
5481
ValueCountFrequency (%) 
SLPOPEARMYAIR081619_V01 6 0.1%
 
SLSTUTTGARTDE111219_V01 6 0.1%
 
SLROBINSAFBGA080819_V01 6 0.1%
 
SLWASHINGTOND031120_V01 5 0.1%
 
ESNORFOLKVA091519_V03 5 0.1%
 
SLSHAWAFBSC082219_V01 5 0.1%
 
SLFAIRCHILDAF092419_V01 5 0.1%
 
SLNORFOLKNAVA012120_V01 5 0.1%
 
SLWASHINGTOND071719_V01 5 0.1%
 
SLAUSTINTX020620_V01 5 0.1%
 
Other values (5003) 5446 99.0%
 
Max length26
Mean length22.47663211
Min length12
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

DocumentType
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
VCH
5333
LVCH
 
166
ValueCountFrequency (%) 
VCH 5333 97.0%
 
LVCH 166 3.0%
 
Max length4
Mean length3.030187307
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

DTAIDEmailAddress
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)6.7%
Missing (n)368
transcom.scott.tcj8.mbx.dts-rejects@mail.mil
5131
(Missing)
 
368
ValueCountFrequency (%) 
transcom.scott.tcj8.mbx.dts-rejects@mail.mil 5131 93.3%
 
(Missing) 368 6.7%
 
Max length44
Mean length41.25622841
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Error_Category
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

ExpensesbyLOA
Numeric

Distinct count3766
Unique (%)68.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1629.298071
Minimum0
Maximum56739.73
Zeros (%)7.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q1225.35
Median775.39
Q31767.6
95-th percentile5694.408
Maximum56739.73
Range56739.73
Interquartile range1542.25

Descriptive statistics

Standard deviation3198.752153
Coef of variation1.96327008
Kurtosis80.50969153
Mean1629.298071
MAD1558.213834
Skewness7.311093677
Sum8959510.09
Variance10232015.34
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 1.5500000e+00 4.0500000e+00 7.4250000e+00 9.0300000e+00 ... 5.8580700e+03 8.0538000e+03 1.2559835e+04 2.4249640e+04 5.6739730e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 433 7.9%
 
91.5 121 2.2%
 
307.5 51 0.9%
 
161.5 42 0.8%
 
176.5 41 0.7%
 
8.35 37 0.7%
 
157.5 29 0.5%
 
211.5 26 0.5%
 
3.1 26 0.5%
 
320 25 0.5%
 
Other values (3756) 4668 84.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 433 7.9%
 
3.1 26 0.5%
 
5 2 < 0.1%
 
5.25 1 < 0.1%
 
6.47 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
56739.73 1 < 0.1%
 
53760.22 1 < 0.1%
 
43908.31 2 < 0.1%
 
42330.84 2 < 0.1%
 
41483.87 2 < 0.1%
 

FinancialReject(Y/N)
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
5445
Y
 
54
ValueCountFrequency (%) 
N 5445 99.0%
 
Y 54 1.0%
 

ForeignTravelFlag
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
3981
Y
1518
ValueCountFrequency (%) 
N 3981 72.4%
 
Y 1518 27.6%
 

FullName
Categorical

Distinct count1154
Unique (%)21.0%
Missing (%)0.0%
Missing (n)0
JAMES SHEPARD
 
38
STEPHEN LYONS
 
37
JOSEPH REICHERT
 
32
Other values (1151)
5392
ValueCountFrequency (%) 
JAMES SHEPARD 38 0.7%
 
STEPHEN LYONS 37 0.7%
 
JOSEPH REICHERT 32 0.6%
 
ANDREA GONZALES 31 0.6%
 
DONALD ABSHER 31 0.6%
 
SHAWN BEDARD 29 0.5%
 
TRACEY TURNER 29 0.5%
 
HORACE TAYLOR 28 0.5%
 
JASON FRANCE 27 0.5%
 
ANDREW KRUCZYK 27 0.5%
 
Other values (1144) 5190 94.4%
 
Max length25
Mean length13.67612293
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

ImproperPaymentCorrections
Numeric

Distinct count58
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean236.2027641
Minimum0
Maximum332306
Zeros (%)96.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum332306
Range332306
Interquartile range0

Descriptive statistics

Standard deviation4666.375408
Coef of variation19.75580356
Kurtosis4666.80792
Mean236.2027641
MAD461.6530748
Skewness65.72940543
Sum1298879
Variance21775059.45
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 7.500000e+00 5.700000e+01 5.900000e+01 9.800000e+01 2.265000e+02 1.711525e+05 3.323060e+05], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5290 96.2%
 
9999 96 1.7%
 
58 16 0.3%
 
1 8 0.1%
 
94 4 0.1%
 
7 4 0.1%
 
4 4 0.1%
 
48 4 0.1%
 
5 3 0.1%
 
162 3 0.1%
 
Other values (48) 67 1.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5290 96.2%
 
1 8 0.1%
 
2 3 0.1%
 
4 4 0.1%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
332306 1 < 0.1%
 
9999 96 1.7%
 
253 1 < 0.1%
 
200 1 < 0.1%
 
194 1 < 0.1%
 

ImproperPayments
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5280
1
 
219
ValueCountFrequency (%) 
0 5280 96.0%
 
1 219 4.0%
 

IncludesSPP(Y/N)
Constant

This variable is constant and should be ignored for analysis

Constant valueN

InputError
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5456
1
 
43
ValueCountFrequency (%) 
0 5456 99.2%
 
1 43 0.8%
 

LastAOApprovedDate
Categorical

Distinct count297
Unique (%)5.4%
Missing (%)0.2%
Missing (n)10
12/2/19
 
83
7/3/19
 
62
2/10/20
 
55
Other values (293)
5289
ValueCountFrequency (%) 
12/2/19 83 1.5%
 
7/3/19 62 1.1%
 
2/10/20 55 1.0%
 
12/4/19 53 1.0%
 
7/22/19 45 0.8%
 
9/23/19 45 0.8%
 
12/18/19 45 0.8%
 
12/3/19 45 0.8%
 
2/3/20 44 0.8%
 
9/16/19 43 0.8%
 
Other values (286) 4969 90.4%
 
Max length8
Mean length6.98108747
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

LOA10by20
Categorical

Distinct count548
Unique (%)10.0%
Missing (%)0.0%
Missing (n)0
387700^97^^X^4930^FD60^6J^0^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^
 
209
387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^
 
202
387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^
 
172
Other values (545)
4916
ValueCountFrequency (%) 
387700^97^^X^4930^FD60^6J^0^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 209 3.8%
 
387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ 202 3.7%
 
387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ 172 3.1%
 
387700^97^^X^4930^FD60^6J^9^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 144 2.6%
 
387700^97^^X^4930^FD60^6J^0^70^FB^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 122 2.2%
 
387700^97^^X^4930^FD60^6J^9^70^FB^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 102 1.9%
 
387700^97^^X^4930^FD60^6J^0^70^FC^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 89 1.6%
 
387700^97^^X^4930^FD60^6J^0^70^D3^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 88 1.6%
 
387700^57^^9^3400^^30^9^70^JE^G3JE40^02^^^^^40924^^^387700^^^21400F^^^^^ 85 1.5%
 
387700^97^^X^4930^FD60^6J^0^70^FA^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ 81 1.5%
 
Other values (538) 4205 76.5%
 
Max length103
Mean length78.5766503
Min length64
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

LOALabel
Categorical

Distinct count547
Unique (%)9.9%
Missing (%)0.0%
Missing (n)0
20 DCS BA MSPT
 
209
20 CMDSEC MSPT
 
202
19 CMDSEC MSPT
 
172
Other values (544)
4916
ValueCountFrequency (%) 
20 DCS BA MSPT 209 3.8%
 
20 CMDSEC MSPT 202 3.7%
 
19 CMDSEC MSPT 172 3.1%
 
19 DCS BA MSPT 144 2.6%
 
20 DCS RS MSPT 122 2.2%
 
19 DCS RS MSPT 102 1.9%
 
20 DCS SG MSPT 89 1.6%
 
20 DCS JA MSPT 88 1.6%
 
19 JR_JPSE 85 1.5%
 
20 DCS BH MSPT 81 1.5%
 
Other values (537) 4205 76.5%
 
Max length15
Mean length12.88343335
Min length5
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Location/Destination(firstonly)
Categorical

Distinct count498
Unique (%)9.1%
Missing (%)9.6%
Missing (n)529
NORFOLK NAVAL STATION,VA
 
289
WASHINGTON,DC
 
228
MACDILL AFB,FL
 
124
Other values (494)
4329
(Missing)
 
529
ValueCountFrequency (%) 
NORFOLK NAVAL STATION,VA 289 5.3%
 
WASHINGTON,DC 228 4.1%
 
MACDILL AFB,FL 124 2.3%
 
SCOTT AFB,IL 121 2.2%
 
PENTAGON,VA 106 1.9%
 
MEMPHIS,TN 106 1.9%
 
RAMSTEIN AB,DEU 97 1.8%
 
SIGONELLA NAS,ITA 93 1.7%
 
MILITARY BASES NOT IN KUWAIT CITY,KWT 82 1.5%
 
SAN ANTONIO,TX 79 1.4%
 
Other values (487) 3645 66.3%
 
(Missing) 529 9.6%
 
Max length47
Mean length14.78868885
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Miscellaneous
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5498
1
 
1
ValueCountFrequency (%) 
0 5498 > 99.9%
 
1 1 < 0.1%
 

Missing_InvalidReceipt_Documentation
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5408
1
 
91
ValueCountFrequency (%) 
0 5408 98.3%
 
1 91 1.7%
 

Month_End
Categorical

Distinct count12
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
9/30/19
 
645
12/31/19
 
612
8/30/19
 
586
Other values (9)
3656
ValueCountFrequency (%) 
9/30/19 645 11.7%
 
12/31/19 612 11.1%
 
8/30/19 586 10.7%
 
10/31/19 583 10.6%
 
2/29/20 555 10.1%
 
6/30/19 534 9.7%
 
7/31/19 532 9.7%
 
3/31/20 516 9.4%
 
11/30/19 380 6.9%
 
1/31/20 368 6.7%
 
Other values (2) 188 3.4%
 
Max length8
Mean length7.286415712
Min length7
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Month_Rank
Highly correlated

This variable is highly correlated with df_index and should be ignored for analysis

Correlation0.9899008813

MultipleLOAs(Y/N)
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
4826
Y
 
673
ValueCountFrequency (%) 
N 4826 87.8%
 
Y 673 12.2%
 

Non-contractFareFlag
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
5117
Y
 
382
ValueCountFrequency (%) 
N 5117 93.1%
 
Y 382 6.9%
 

Organization/Suborganization
Categorical

Distinct count32
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
DJ60TCJECC_JPSE
918
DJ60TCJ5
 
533
DJ60TCJ3
 
433
Other values (29)
3615
ValueCountFrequency (%) 
DJ60TCJECC_JPSE 918 16.7%
 
DJ60TCJ5 533 9.7%
 
DJ60TCJ3 433 7.9%
 
DJ60TCCC 400 7.3%
 
DJ60TCJ3DCSBA 364 6.6%
 
DJ60TCJECC 321 5.8%
 
DJ60TCJ3DCSRS 251 4.6%
 
DJ60TCJ3DCSSG 175 3.2%
 
DJ60TCSG 162 2.9%
 
DJ60TCJ3DCSBH 160 2.9%
 
Other values (22) 1782 32.4%
 
Max length15
Mean length11.11929442
Min length8
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Overpayments(Debts)*
Numeric

Distinct count162
Unique (%)2.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean17.21950173
Minimum0
Maximum6823.82
Zeros (%)97.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum6823.82
Range6823.82
Interquartile range0

Descriptive statistics

Standard deviation210.0849428
Coef of variation12.20040778
Kurtosis589.6229387
Mean17.21950173
MAD33.4107544
Skewness22.12386129
Sum94690.04
Variance44135.68318
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000e+00 3.80500e+00 9.67550e+01 3.29650e+02 7.04350e+02 1.77073e+03 6.82382e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5332 97.0%
 
55 2 < 0.1%
 
558 2 < 0.1%
 
504 2 < 0.1%
 
30.5 2 < 0.1%
 
220.6 2 < 0.1%
 
28 2 < 0.1%
 
26.94 1 < 0.1%
 
32.78 1 < 0.1%
 
376 1 < 0.1%
 
Other values (152) 152 2.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5332 97.0%
 
7.61 1 < 0.1%
 
8 1 < 0.1%
 
8.35 1 < 0.1%
 
11 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6823.82 1 < 0.1%
 
6776.5 1 < 0.1%
 
5407.5 1 < 0.1%
 
4564.65 1 < 0.1%
 
4472.54 1 < 0.1%
 

Overpayments_(Debts)*
Highly correlated

This variable is highly correlated with Overpayments(Debts)* and should be ignored for analysis

Correlation1

PNRRecordLocator(allshown)
Categorical

Distinct count3267
Unique (%)59.4%
Missing (%)31.4%
Missing (n)1729
QXRTCZ
 
10
MU7XPH
 
8
UPOMOM
 
8
Other values (3263)
3744
(Missing)
1729
ValueCountFrequency (%) 
QXRTCZ 10 0.2%
 
MU7XPH 8 0.1%
 
UPOMOM 8 0.1%
 
XHAYAN 6 0.1%
 
2P32PJ OFOJ6S 6 0.1%
 
NPN5FB 6 0.1%
 
NCHNGM 5 0.1%
 
EQWCXJ 5 0.1%
 
OLLF6J 5 0.1%
 
2MVC3M 4 0.1%
 
Other values (3256) 3707 67.4%
 
(Missing) 1729 31.4%
 
Max length20
Mean length5.330423713
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Receiptdoesnotmatchclaim
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5429
1
 
70
ValueCountFrequency (%) 
0 5429 98.7%
 
1 70 1.3%
 

Reference
Categorical

Distinct count111
Unique (%)2.0%
Missing (%)95.0%
Missing (n)5222
80NF
 
52
RS
 
16
FX/BWI
 
10
Other values (107)
 
199
(Missing)
5222
ValueCountFrequency (%) 
80NF 52 0.9%
 
RS 16 0.3%
 
FX/BWI 10 0.2%
 
WP 10 0.2%
 
RD/NE 8 0.1%
 
80/NF 7 0.1%
 
BA3 6 0.1%
 
FLY NE 6 0.1%
 
BA10/11 6 0.1%
 
FLY 12/15/82 6 0.1%
 
Other values (100) 150 2.7%
 
(Missing) 5222 95.0%
 
Max length30
Mean length3.311329333
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Regulation_Unauthorized
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
5389
1
 
110
ValueCountFrequency (%) 
0 5389 98.0%
 
1 110 2.0%
 

ReturnDate
Categorical

Distinct count467
Unique (%)8.5%
Missing (%)0.0%
Missing (n)0
2/1/20
 
60
9/20/19
 
58
9/27/19
 
58
Other values (464)
5323
ValueCountFrequency (%) 
2/1/20 60 1.1%
 
9/20/19 58 1.1%
 
9/27/19 58 1.1%
 
12/13/19 57 1.0%
 
6/15/19 57 1.0%
 
11/22/19 56 1.0%
 
1/31/20 55 1.0%
 
3/14/20 53 1.0%
 
10/30/19 53 1.0%
 
9/30/19 48 0.9%
 
Other values (457) 4944 89.9%
 
Max length8
Mean length7.013456992
Min length6
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Reviewed_Record
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
4556
1
943
ValueCountFrequency (%) 
0 4556 82.9%
 
1 943 17.1%
 

ReviewedVouchers
Highly correlated

This variable is highly correlated with Reviewed_Record and should be ignored for analysis

Correlation1

SDN(representativeSDNfordoctype)
Categorical

Distinct count4942
Unique (%)89.9%
Missing (%)0.5%
Missing (n)28
2CT6YJ TD
 
10
2CKT31 TD
 
6
2CWX4L TD
 
6
Other values (4938)
5449
(Missing)
 
28
ValueCountFrequency (%) 
2CT6YJ TD 10 0.2%
 
2CKT31 TD 6 0.1%
 
2CWX4L TD 6 0.1%
 
26UZR4 TD 6 0.1%
 
2BBQ9U 5 0.1%
 
2C7V91 TD 5 0.1%
 
2A38PA TD 5 0.1%
 
2BBQ9U TD 5 0.1%
 
2D49YM TD 4 0.1%
 
2CUTTU TD 4 0.1%
 
Other values (4931) 5415 98.5%
 
(Missing) 28 0.5%
 
Max length19
Mean length9.962720495
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Sent_Date
Categorical

Distinct count15
Unique (%)0.3%
Missing (%)96.1%
Missing (n)5283
8/21/19
 
43
10/31/19
 
41
12/5/19
 
34
Other values (11)
 
98
(Missing)
5283
ValueCountFrequency (%) 
8/21/19 43 0.8%
 
10/31/19 41 0.7%
 
12/5/19 34 0.6%
 
5/4/20 25 0.5%
 
7/16/19 18 0.3%
 
3/10/20 16 0.3%
 
7/17/19 8 0.1%
 
5/12/20 7 0.1%
 
2/21/20 7 0.1%
 
11/4/19 7 0.1%
 
Other values (4) 10 0.2%
 
(Missing) 5283 96.1%
 
Max length8
Mean length3.160029096
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

SignedDate
Categorical

Distinct count355
Unique (%)6.5%
Missing (%)< 0.1%
Missing (n)1
11/25/19
 
60
9/30/19
 
56
9/9/19
 
46
Other values (351)
5336
ValueCountFrequency (%) 
11/25/19 60 1.1%
 
9/30/19 56 1.0%
 
9/9/19 46 0.8%
 
11/26/19 46 0.8%
 
8/20/19 44 0.8%
 
3/9/20 43 0.8%
 
12/18/19 42 0.8%
 
1/21/20 41 0.7%
 
2/3/20 41 0.7%
 
10/15/19 41 0.7%
 
Other values (344) 5038 91.6%
 
Max length8
Mean length6.994544463
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

SpecialCircumstancesTripType
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

SPPReject(Y/N)
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)6.7%
Missing (n)368
N
5131
(Missing)
 
368
ValueCountFrequency (%) 
N 5131 93.3%
 
(Missing) 368 6.7%
 
Max length3
Mean length1.133842517
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

SSN
Categorical

Distinct count1077
Unique (%)19.6%
Missing (%)6.7%
Missing (n)368
*****6633
 
37
*****3312
 
35
*****887R
 
31
Other values (1073)
5028
(Missing)
 
368
ValueCountFrequency (%) 
*****6633 37 0.7%
 
*****3312 35 0.6%
 
*****887R 31 0.6%
 
*****3829 28 0.5%
 
*****2061 28 0.5%
 
*****9772 27 0.5%
 
*****2662 26 0.5%
 
*****0507 26 0.5%
 
*****8714 26 0.5%
 
*****7831 26 0.5%
 
Other values (1066) 4841 88.0%
 
(Missing) 368 6.7%
 
Max length9
Mean length8.59847245
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

T-EnteredFlag
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
5419
Y
 
80
ValueCountFrequency (%) 
N 5419 98.5%
 
Y 80 1.5%
 

TANum
Categorical

Distinct count4887
Unique (%)88.9%
Missing (%)0.0%
Missing (n)0
2BBQ9U
 
10
2CT6YJ
 
10
2747I7
 
8
Other values (4884)
5471
ValueCountFrequency (%) 
2BBQ9U 10 0.2%
 
2CT6YJ 10 0.2%
 
2747I7 8 0.1%
 
2CKT31 6 0.1%
 
26XOI2 6 0.1%
 
26UZR4 6 0.1%
 
2CWX4L 6 0.1%
 
2CYM1U 6 0.1%
 
2C7V91 5 0.1%
 
2CQE7V 5 0.1%
 
Other values (4877) 5431 98.8%
 
Max length6
Mean length6
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

TotalCP-C/CR-CAmount
Numeric

Distinct count19
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean4.068894344
Minimum0
Maximum13278.15
Zeros (%)99.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum13278.15
Range13278.15
Interquartile range0

Descriptive statistics

Standard deviation182.6894517
Coef of variation44.89904043
Kurtosis5074.461029
Mean4.068894344
MAD8.106711482
Skewness70.0678505
Sum22374.85
Variance33375.43576
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=19)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 4.175000e+00 6.432000e+02 1.327815e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5478 99.6%
 
457.4 2 < 0.1%
 
212.8 2 < 0.1%
 
8.35 2 < 0.1%
 
623.6 1 < 0.1%
 
1949 1 < 0.1%
 
497.6 1 < 0.1%
 
426.5 1 < 0.1%
 
278.8 1 < 0.1%
 
494.28 1 < 0.1%
 
Other values (9) 9 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5478 99.6%
 
8.35 2 < 0.1%
 
32.02 1 < 0.1%
 
212.8 2 < 0.1%
 
220.6 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13278.15 1 < 0.1%
 
1949 1 < 0.1%
 
662.8 1 < 0.1%
 
623.6 1 < 0.1%
 
575.3 1 < 0.1%
 

TotalCP/CRAmount
Numeric

Distinct count1153
Unique (%)21.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean349.6803673
Minimum0
Maximum5218.05
Zeros (%)52.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q3499.8
95-th percentile1397.451
Maximum5218.05
Range5218.05
Interquartile range499.8

Descriptive statistics

Standard deviation576.8844909
Coef of variation1.649748012
Kurtosis13.74087923
Mean349.6803673
MAD390.8086792
Skewness3.048717964
Sum1922892.34
Variance332795.7159
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 3.115000e+00 1.008000e+02 1.118500e+02 2.121000e+02 ... 1.597980e+03 1.601980e+03 2.071640e+03 2.800665e+03 5.218050e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 2891 52.6%
 
220.6 68 1.2%
 
280.6 50 0.9%
 
212.8 48 0.9%
 
212.6 37 0.7%
 
278.6 36 0.7%
 
658.6 30 0.5%
 
278.8 30 0.5%
 
706.6 23 0.4%
 
1348.61 21 0.4%
 
Other values (1143) 2265 41.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2891 52.6%
 
6.23 1 < 0.1%
 
8.35 1 < 0.1%
 
81.3 2 < 0.1%
 
83.3 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5218.05 2 < 0.1%
 
5104.99 2 < 0.1%
 
4885.28 2 < 0.1%
 
4788.33 1 < 0.1%
 
4458.95 1 < 0.1%
 

TotalDaysTDY
Numeric

Distinct count115
Unique (%)2.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.534097109
Minimum1
Maximum382
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median4
Q37
95-th percentile37.1
Maximum382
Range381
Interquartile range5

Descriptive statistics

Standard deviation22.89717298
Coef of variation2.401608954
Kurtosis106.6839831
Mean9.534097109
MAD9.598986554
Skewness8.746903959
Sum52428
Variance524.2805305
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 5.5 ... 69.5 72. 94. 147.5 382. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 1290 23.5%
 
3 769 14.0%
 
4 540 9.8%
 
1 532 9.7%
 
5 480 8.7%
 
6 341 6.2%
 
7 174 3.2%
 
8 161 2.9%
 
13 100 1.8%
 
9 95 1.7%
 
Other values (105) 1017 18.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 532 9.7%
 
2 1290 23.5%
 
3 769 14.0%
 
4 540 9.8%
 
5 480 8.7%
 

Maximum 5 values

ValueCountFrequency (%) 
382 4 0.1%
 
354 2 < 0.1%
 
282 6 0.1%
 
271 1 < 0.1%
 
262 2 < 0.1%
 

TotalInputError
Highly correlated

This variable is highly correlated with InputError and should be ignored for analysis

Correlation1

TotalMiscellaneous
Highly correlated

This variable is highly correlated with Miscellaneous and should be ignored for analysis

Correlation1

TotalMissingInvalidReceiptDocumentation
Highly correlated

This variable is highly correlated with Missing_InvalidReceipt_Documentation and should be ignored for analysis

Correlation1

TotalReceiptDoesNotMatchClaim
Highly correlated

This variable is highly correlated with Receiptdoesnotmatchclaim and should be ignored for analysis

Correlation1

TotalRegulationUnauthorized
Highly correlated

This variable is highly correlated with Regulation_Unauthorized and should be ignored for analysis

Correlation1

TotalReimbursableExpenses
Highly correlated

This variable is highly correlated with AmountClaim and should be ignored for analysis

Correlation0.9993386598

TotalTripExpenses
Highly correlated

This variable is highly correlated with TotalReimbursableExpenses and should be ignored for analysis

Correlation0.9988470133

Travel_Location
Categorical

Distinct count498
Unique (%)9.1%
Missing (%)9.6%
Missing (n)529
NORFOLK NAVAL STATION,VA
 
289
WASHINGTON,DC
 
228
MACDILL AFB,FL
 
124
Other values (494)
4329
(Missing)
 
529
ValueCountFrequency (%) 
NORFOLK NAVAL STATION,VA 289 5.3%
 
WASHINGTON,DC 228 4.1%
 
MACDILL AFB,FL 124 2.3%
 
SCOTT AFB,IL 121 2.2%
 
PENTAGON,VA 106 1.9%
 
MEMPHIS,TN 106 1.9%
 
RAMSTEIN AB,DEU 97 1.8%
 
SIGONELLA NAS,ITA 93 1.7%
 
MILITARY BASES NOT IN KUWAIT CITY,KWT 82 1.5%
 
SAN ANTONIO,TX 79 1.4%
 
Other values (487) 3645 66.3%
 
(Missing) 529 9.6%
 
Max length47
Mean length14.78868885
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

TravelerEmailAddress
Categorical

Distinct count1152
Unique (%)20.9%
Missing (%)6.7%
Missing (n)368
james.e.shepard22.mil@mail.mil
 
73
donald.b.absher.mil@mail.mil
 
31
kayla.m.georgiafandis.mil@mail.mil
 
28
Other values (1148)
4999
(Missing)
 
368
ValueCountFrequency (%) 
james.e.shepard22.mil@mail.mil 73 1.3%
 
donald.b.absher.mil@mail.mil 31 0.6%
 
kayla.m.georgiafandis.mil@mail.mil 28 0.5%
 
JOSEPH.REICHERT@US.AF.MIL 28 0.5%
 
shawn.m.bedard.mil@mail.mil 27 0.5%
 
stewart.harrison@me.navy.mil 26 0.5%
 
tracey.turner.3@us.af.mil 26 0.5%
 
ANDREA.GONZALES.5@US.AF.MIL 26 0.5%
 
horace.e.taylor13.mil@mail.mil 26 0.5%
 
andrew.kruczyk@us.af.mil 25 0.5%
 
Other values (1141) 4815 87.6%
 
(Missing) 368 6.7%
 
Max length55
Mean length25.74777232
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

TravelerFirstName
Categorical

Distinct count616
Unique (%)11.2%
Missing (%)0.0%
Missing (n)0
CHRISTOPHER
 
122
JAMES
 
120
MATTHEW
 
98
Other values (613)
5159
ValueCountFrequency (%) 
CHRISTOPHER 122 2.2%
 
JAMES 120 2.2%
 
MATTHEW 98 1.8%
 
JOHN 93 1.7%
 
DAVID 92 1.7%
 
MICHAEL 90 1.6%
 
ROBERT 85 1.5%
 
ANDREW 74 1.3%
 
WILLIAM 73 1.3%
 
RICHARD 70 1.3%
 
Other values (606) 4582 83.3%
 
Max length15
Mean length6.142389525
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

TravelerLastName
Categorical

Distinct count1005
Unique (%)18.3%
Missing (%)0.0%
Missing (n)0
JOHNSON
 
57
JONES
 
47
TURNER
 
45
Other values (1002)
5350
ValueCountFrequency (%) 
JOHNSON 57 1.0%
 
JONES 47 0.9%
 
TURNER 45 0.8%
 
WILLIAMS 40 0.7%
 
Shepard 38 0.7%
 
LYONS 37 0.7%
 
SMITH 37 0.7%
 
REICHERT 32 0.6%
 
ABSHER 31 0.6%
 
GONZALES 31 0.6%
 
Other values (995) 5104 92.8%
 
Max length18
Mean length6.533733406
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

TripDescription
Categorical

Distinct count3510
Unique (%)63.8%
Missing (%)21.7%
Missing (n)1194
DELIVERY OF CLASSIFED COURIER MATERIAL
 
28
Deliver DCS material
 
16
Delivery of classified material.
 
14
Other values (3506)
4247
(Missing)
1194
ValueCountFrequency (%) 
DELIVERY OF CLASSIFED COURIER MATERIAL 28 0.5%
 
Deliver DCS material 16 0.3%
 
Delivery of classified material. 14 0.3%
 
Courier duties; escort DCS material 13 0.2%
 
Delivery of DCS Material 11 0.2%
 
TDY 10 0.2%
 
DoD Courier Mission. 9 0.2%
 
Delivering DCS material 8 0.1%
 
Delivery of classified courier material. 8 0.1%
 
Attending 42A Advance Leader Course at Fort Jackson South Carolina. Will also be taking leave after completing ALC.PNR Locator:UPOMOM 8 0.1%
 
Other values (3499) 4180 76.0%
 
(Missing) 1194 21.7%
 
Max length1458
Mean length44.65048191
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

TripPurpose
Categorical

Distinct count13
Unique (%)0.2%
Missing (%)3.0%
Missing (n)166
MISSION - OPERATIONAL
2999
TRAINING
1258
CONFERENCE- NON-TRAINING
 
442
Other values (9)
634
ValueCountFrequency (%) 
MISSION - OPERATIONAL 2999 54.5%
 
TRAINING 1258 22.9%
 
CONFERENCE- NON-TRAINING 442 8.0%
 
SPECIAL AGENCY MISSION 328 6.0%
 
TRAINING ATTENDANCE 105 1.9%
 
OTHER TRAVEL 81 1.5%
 
SPECIAL MISSION TRAVEL 60 1.1%
 
SITE VISIT 21 0.4%
 
EMERGENCY - PERSONAL 18 0.3%
 
CONFERENCE ATTENDANCE 12 0.2%
 
Other values (2) 9 0.2%
 
(Missing) 166 3.0%
 
Max length24
Mean length17.57719585
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

TripType
Categorical

Distinct count8
Unique (%)0.1%
Missing (%)3.0%
Missing (n)166
Temporary Duty Travel (Routine)
5286
Invitational Travel
 
12
Dependent Invitational Travel
 
10
Other values (4)
 
25
(Missing)
 
166
ValueCountFrequency (%) 
Temporary Duty Travel (Routine) 5286 96.1%
 
Invitational Travel 12 0.2%
 
Dependent Invitational Travel 10 0.2%
 
Dependent Invitational Travel - Transportation Expenses Only 9 0.2%
 
AA-ROUTINE TDY/TAD 9 0.2%
 
Government Funded Leave 6 0.1%
 
Invitational Travel - Transportation Expenses Only 1 < 0.1%
 
(Missing) 166 3.0%
 
Max length60
Mean length30.1458447
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Underpayments(Credits)*
Numeric

Distinct count57
Unique (%)1.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.961745772
Minimum0
Maximum3428.7
Zeros (%)98.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum3428.7
Range3428.7
Interquartile range0

Descriptive statistics

Standard deviation55.51183748
Coef of variation28.29716178
Kurtosis2949.234936
Mean1.961745772
MAD3.873183414
Skewness51.72512377
Sum10787.64
Variance3081.564101
Memory size43.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 4.0000e+01 1.7859e+02 4.9193e+02 3.4287e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5428 98.7%
 
8.35 5 0.1%
 
30.5 4 0.1%
 
28 3 0.1%
 
33 2 < 0.1%
 
46 2 < 0.1%
 
38 2 < 0.1%
 
13.75 2 < 0.1%
 
27.5 2 < 0.1%
 
10 2 < 0.1%
 
Other values (47) 47 0.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5428 98.7%
 
1 1 < 0.1%
 
3.16 1 < 0.1%
 
6.36 1 < 0.1%
 
8.35 5 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3428.7 1 < 0.1%
 
1998.43 1 < 0.1%
 
584.5 1 < 0.1%
 
399.36 1 < 0.1%
 
384.79 1 < 0.1%
 

Underpayments_(Credits)*
Highly correlated

This variable is highly correlated with Underpayments(Credits)* and should be ignored for analysis

Correlation1

Correlations

Missing values

Sample

First rows

Actuals(Y/N)AdvanceAmountAdvanceReject(Y/N)AdvisoryAmountClaimAOEmailAddressAutoKeyAwaitingStatusCancelledDateChanges_Needed_(Y/N)CommentsConstructiveTravelFlagCorrected_DateCorrectedVouchersCurrentStatusCurrentVersionCompletedDateDateofCurrentStatusDCSSuborganizationDepartureDatedf_indexDirectorateDocumentCreateDateDocumentNameDocumentTypeDTAIDEmailAddressError_CategoryExpensesbyLOAFinancialReject(Y/N)ForeignTravelFlagFullNameImproperPaymentCorrectionsImproperPaymentsIncludesSPP(Y/N)InputErrorLastAOApprovedDateLOA10by20LOALabelLocation/Destination(firstonly)MiscellaneousMissing_InvalidReceipt_DocumentationMonth_EndMonth_RankMultipleLOAs(Y/N)Non-contractFareFlagOrganization/SuborganizationOverpayments(Debts)*Overpayments_(Debts)*PNRRecordLocator(allshown)ReceiptdoesnotmatchclaimReferenceRegulation_UnauthorizedReturnDateReviewed_RecordReviewedVouchersSDN(representativeSDNfordoctype)Sent_DateSignedDateSpecialCircumstancesTripTypeSPPReject(Y/N)SSNT-EnteredFlagTANumTotalCP-C/CR-CAmountTotalCP/CRAmountTotalDaysTDYTotalInputErrorTotalMiscellaneousTotalMissingInvalidReceiptDocumentationTotalReceiptDoesNotMatchClaimTotalRegulationUnauthorizedTotalReimbursableExpensesTotalTripExpensesTravel_LocationTravelerEmailAddressTravelerFirstNameTravelerLastNameTripDescriptionTripPurposeTripTypeUnderpayments(Credits)*Underpayments_(Credits)*
0N0.0N0.05999.20michael.w.muskopf.civ@mail.mil69710.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT5/5/205/6/20NaN1/12/200TCAQ5/5/20CLMAXWELLAFBA011220_V01-01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN5999.20NNCHAD LINDAUER0.00.0N0.05/5/20387700^57^^0^3400^^30^^64^ET^1L3L24^03^^^^^40915^^^387700^^^84751F^^^^^20 1L3L24MAXWELL AFB,AL0.00.05/31/201.0NNDJ60TCAQ0.000.00NaN0.0NaN0.02/27/200.00.02DMMRK TDNaN5/5/20NaNN*****3308N2DMMRK0.00.047.00.00.00.00.00.05999.205999.20MAXWELL AFB,ALchad.s.lindauer.civ@mail.milCHADLINDAUERTLN 9S3T000017Course Title: SQUADRON OFFICER SCHOOLCourse #: MSOS 001 CLASSNumber: 2020BCSD: 13 JAN 2020 - CGD: 27 FEB 2020Location: MAXWELL AFBTRAININGTemporary Duty Travel (Routine)0.00.0
1N0.0N0.00.00mary.b.gaffney.civ@mail.mil69711.0NaNNaNNoOkayNNaN0.0ARCHIVE ACCEPTED5/14/205/15/20NaN3/23/202TCAQ3/12/20TTCOLUMBUSOH032320_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN0.00NNTAMARA THOUVENOT0.00.0N0.05/14/20387700^97^^X^4930^FD50^6F^0^70^AB^G04N70^^_12400^^^^40924^^^387700^^^48090D^^^^^20 TCAQ MSPTCOLUMBUS,OH0.00.05/31/201.0NNDJ60TCAQ0.000.00NaN0.0NaN0.03/24/201.01.02E56SM TDNaN5/14/20NaNN*****4081N2E56SM0.00.02.00.00.00.00.00.00.000.00COLUMBUS,OHtamara.d.thouvenot.civ@mail.milTAMARATHOUVENOTDLA Land and Maritime Guest SpeakerPNR Locator:N3D8YZMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
2N0.0N0.0254.51brian.l.paul2.civ@mail.mil69712.0NaNNaNNoOkayNNaN0.0REJECT5/15/205/18/20NaN9/12/193TCCC4/23/20ABSTLOUISMO091219_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN787.36YNALAN BECKENSTEIN0.00.0N0.05/15/20387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^19 CMDSEC MSPTST. LOUIS,MO0.00.05/31/201.0NNDJ60TCCC0.000.004N42B20.0NaN0.09/13/191.01.02CS1JU TDNaN5/15/20NaNN*****6524Y2CS1JU524.50.02.00.00.00.00.00.0254.51787.36ST. LOUIS,MOkendall.e.martin2.civ@mail.milAlanBeckensteinPNR Locator:4N42B2TRAININGInvitational Travel0.00.0
3N0.0N0.0135.00richard.h.espinosa.mil@mail.mil69713.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT5/15/205/18/20NaN10/10/194TCCC5/13/20DM101019_L01.4-01LVCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN135.00NNDEE MEWBOURNE0.00.0N0.05/15/20387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^20 CMDSEC MSPTNaN0.00.05/31/201.0NNDJ60TCCC0.000.00NaN0.0NDTA Fall Meeting0.010/10/190.00.02D0XUV TDNaN5/13/20NaNN*****6477N2D0XUV0.00.01.00.00.00.00.00.0135.00135.00NaNkayla.m.georgiafandis.mil@mail.milDEEMEWBOURNENaNNaNNaN0.00.0
4N0.0N0.08.35richard.h.espinosa.mil@mail.mil69714.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT5/11/205/12/20NaN12/11/195TCCC5/7/20DMWASHINGTOND121119_V02-01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN8.35NNDEE MEWBOURNE0.00.0N0.05/11/20387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^20 CMDSEC MSPTWASHINGTON,DC0.00.05/31/201.0NNDJ60TCCC0.000.0074FPOO0.0NaN0.012/12/190.00.02DGYP1 TDNaN5/11/20NaNN*****6477N2DGYP10.00.02.00.00.00.00.00.08.358.35WASHINGTON,DCkayla.m.georgiafandis.mil@mail.milDEEMEWBOURNEAttending NDTA Holiday Reception and Board of Directors followed by 3 days of personal leavePNR Locator:74FPOOMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5N0.0N0.016.70richard.h.espinosa.mil@mail.mil69715.0NaNNaNNoOkayNNaN0.0ARCHIVE IMAGE ACCEPT5/15/205/19/20NaN3/17/206TCCC3/13/20KTSEATTLEWA031320_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN16.70NNKHRISTIAN THOMPSON0.00.0N0.05/15/20387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^20 CMDSEC MSPTWASHINGTON NAVAL DISTRICT,DC0.00.05/31/201.0NNDJ60TCCC0.000.00NaN0.0NaN0.03/18/201.01.02EGVDH TDNaN5/13/20NaNN*****0105N2EGVDH0.00.02.00.00.00.00.00.016.7016.70WASHINGTON NAVAL DISTRICT,DCkhristian.b.thompson.mil@mail.milKHRISTIANTHOMPSONConduct Advance Protective Security Operations in support of a TDY of the CDRUSTRANSCOMPNR Locator:73F24S PNR Locator:L3FEFLMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
6N0.0N0.0113.82DEON.C.EVANS2.MIL@MAIL.MIL69716.0NaNNaNYesTraveler claimed the mileage from his home to SIU Edwardsville was 66 miles. According to Google it is 32.6. When claiming local mileage you can only claim the mileage above what your daily commute to the Duty Station. His daily commute is 6.1 miles, he entered it as 33 miles. 66-33 = 33 but it should have been 33 - 6 = 27. Traveler was over paid 12 miles a day for a total of $20.64. Please correct mileage numbers.NNaN0.0ARCHIVE ACCEPTED5/21/205/22/20NaN3/10/207TCJ13/13/20MR031320_L01LVCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN113.82NNMITCHELL ROBINSON9999.01.0N1.05/21/20387700^97^^X^4930^FD50^6F^0^70^AB^G041D0^^_12400^^^^40924^^^387700^^^48090D^^^^^20 J1 MSPTNaN0.00.05/31/201.0NNDJ60TCJ120.6420.64NaN0.0NaN1.03/12/201.01.02FELUP TDNaN3/16/20NaNN*****2723N2FELUP0.00.03.01.00.00.00.01.0113.82113.82NaNmitchell.j.robinson6.civ@mail.milMITCHELLROBINSONNaNNaNNaN0.00.0
7N0.0N0.04010.33donald.d.johnson70.mil@mail.mil69717.0NaNNaNYesTraveler claimed a Roadside Assistance protection fee he was charged on his rental receipt, which is not an authorized reimbursement. This service is included in the GARS fee he was charged. Rental car claim needs to be reduced by $118.83. Traveler should contact Enterprise and see if he can get them to remove the charge and provide him a credit.NNaN0.0ARCHIVE IMAGE ACCEPT5/26/205/27/20NaN5/3/2011TCJ15/21/20WJSANANTONIOT050320_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN4010.33NNWISTARIA JOSEPH9999.01.0N0.05/26/20387700^57^^0^3400^^30^^15^4A^BKOPB1^04^^^^^40924^^^387700^^^91212F^^^^^20 3AFELMSAN ANTONIO,TX0.00.05/31/201.0YNDJ60TCJ1118.83118.833NL75D0.0NaN1.05/20/201.01.02F41TY TDNaN5/24/20NaNN*****6411N2F41TY0.0659.218.00.00.00.00.01.04010.334010.33SAN ANTONIO,TXwistaria.j.joseph.mil@mail.milWISTARIAJOSEPHPNR Locator:3NL75DMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
8N0.0N0.04010.33donald.d.johnson70.mil@mail.mil69718.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT5/26/205/27/20NaN5/3/2014TCJ15/21/20WJSANANTONIOT050320_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN0.00NNWISTARIA JOSEPH0.00.0N0.05/26/20387700^97^^X^4930^FD50^6F^0^70^AB^G041D0^^_12400^^^^40924^^^387700^^^48090D^^^^^20 J1 MSPTSAN ANTONIO,TX0.00.05/31/201.0YNDJ60TCJ10.000.003NL75D0.0NaN0.05/20/200.00.02F41TY TDNaN5/24/20NaNN*****6411N2F41TY0.0659.218.00.00.00.00.00.04010.334010.33SAN ANTONIO,TXwistaria.j.joseph.mil@mail.milWISTARIAJOSEPHPNR Locator:3NL75DMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
9Y0.0N0.07700.30peggy.a.beahm.civ@mail.mil69719.0NaNNaNNoOkayYNaN0.0ARCHIVE IMAGE ACCEPT5/20/205/21/20NaN3/16/2015TCJ35/19/20ARLITTLEROCKA031620_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN7700.30NNANDREW RODDAN0.00.0N0.05/20/20387700^57^^0^3400^^30^^65^MD^330000^02^^^^^40924^^^387700^^^41132F^^^^^20 GRP NON FLY1LITTLE ROCK AFB,AR0.00.05/31/201.0NNDJ60TCJ30.000.00NaN0.0NaN0.05/13/201.01.02EARVV TDNaN5/20/20NaNN*****1749N2EARVV0.00.059.00.00.00.00.00.07700.307700.30LITTLE ROCK AFB,ARandrew.l.roddan.mil@mail.milANDREWRODDANC-130J RequalCourse PXC2020X14 TLN: OD3T000003TRAININGTemporary Duty Travel (Routine)0.00.0

Last rows

Actuals(Y/N)AdvanceAmountAdvanceReject(Y/N)AdvisoryAmountClaimAOEmailAddressAutoKeyAwaitingStatusCancelledDateChanges_Needed_(Y/N)CommentsConstructiveTravelFlagCorrected_DateCorrectedVouchersCurrentStatusCurrentVersionCompletedDateDateofCurrentStatusDCSSuborganizationDepartureDatedf_indexDirectorateDocumentCreateDateDocumentNameDocumentTypeDTAIDEmailAddressError_CategoryExpensesbyLOAFinancialReject(Y/N)ForeignTravelFlagFullNameImproperPaymentCorrectionsImproperPaymentsIncludesSPP(Y/N)InputErrorLastAOApprovedDateLOA10by20LOALabelLocation/Destination(firstonly)MiscellaneousMissing_InvalidReceipt_DocumentationMonth_EndMonth_RankMultipleLOAs(Y/N)Non-contractFareFlagOrganization/SuborganizationOverpayments(Debts)*Overpayments_(Debts)*PNRRecordLocator(allshown)ReceiptdoesnotmatchclaimReferenceRegulation_UnauthorizedReturnDateReviewed_RecordReviewedVouchersSDN(representativeSDNfordoctype)Sent_DateSignedDateSpecialCircumstancesTripTypeSPPReject(Y/N)SSNT-EnteredFlagTANumTotalCP-C/CR-CAmountTotalCP/CRAmountTotalDaysTDYTotalInputErrorTotalMiscellaneousTotalMissingInvalidReceiptDocumentationTotalReceiptDoesNotMatchClaimTotalRegulationUnauthorizedTotalReimbursableExpensesTotalTripExpensesTravel_LocationTravelerEmailAddressTravelerFirstNameTravelerLastNameTripDescriptionTripPurposeTripTypeUnderpayments(Credits)*Underpayments_(Credits)*
5489N0.0N0.06164.12jonathan.gilbert@jte.osd.mil63055.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/6/196/8/19NaN5/6/197123TCSG5/24/19MHFRANKFURTAM050519_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN6164.12NYMICHELE HOLDERNESS0.00.0N0.06/6/19012148^097^^0460^^20182019^^^^0600030605814OTE^10156^340508^^16723446^10807^^3131^^^18 DOTE JIMTMFRANKFURT AM MAIN,DEU0.00.06/30/1912.0NYDJ60TCSG0.00.02JCV360.0NaN0.05/17/190.00.02AU999NaN6/5/19NaNN*****9116N2AU9990.02153.1412.00.00.00.00.00.06164.126164.12FRANKFURT AM MAIN,DEUmichele.j.holderness.mil@mail.milMICHELEHOLDERNESSJIMTM TPMRC Close downPNR Locator:2JCV36MISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5490Y0.0N0.0786.25jonathan.gilbert@jte.osd.mil63056.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/11/196/13/19NaN5/28/197124TCSG6/4/19MHSUFFOLKVA052819_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN786.25NNMICHELE HOLDERNESS0.00.0N0.06/11/19012148^097^^0460^^20182019^^^^0600030605814OTE^10156^340508^^16723446^10807^^3131^^^18 DOTE JIMTMSUFFOLK,VA0.00.06/30/1912.0NNDJ60TCSG0.00.03WJ9WP0.0NaN0.05/30/190.00.02B81T0NaN6/10/19NaNN*****9116N2B81T00.0354.503.00.00.00.00.00.0786.25786.25SUFFOLK,VAmichele.j.holderness.mil@mail.milMICHELEHOLDERNESSJI-MTM DRB BoardPNR Locator:3WJ9WPMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5491N0.0N0.04706.63patrick.a.martinez4.mil@mail.mil63057.0NaNNaNNaNNaNNNaN0.0POS ACK RECEIVED6/19/196/24/19NaN5/12/197125TCSG6/18/19MSBANGKOKTHA051119_V01-01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN4512.39NYMARCUS SNYDER0.00.0N0.06/19/19056521^17^19^19^1804^11CQ^2110^07411^^056521^2D^^N00038^J4^E2^VG^1A10^^^^6412^8522^AA^^^^^^19 APRI 36412BANGKOK,THA0.00.06/30/1912.0NNDJ60TCSG0.00.0NDONZ80.0NaN0.05/19/190.00.0N0003819TOATKDDNaN6/18/19NaNN*****1604N2ATKDD0.02688.138.00.00.00.00.00.04512.394512.39BANGKOK,THAMARCUS.SNYDER@us.af.milMARCUSSNYDERNepal Subject Matter Expert ExchangePNR Locator:NDONZ8MISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5492N0.0N0.01666.60patrick.a.martinez4.mil@mail.mil63058.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/25/196/26/19NaN3/3/197126TCSG4/30/19JAWASHINGTOND030419_V04-01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN1666.60NNJOHN ANDRUS0.00.0N0.06/25/19387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^19 SG HQ MSPT XWASHINGTON,DC0.00.06/30/1912.0NNDJ60TCSG0.00.0LRHNDY0.0NaN0.03/6/190.00.029OX2C TDNaN6/25/19NaNN*****5797N29OX2C0.0349.304.00.00.00.00.00.01666.601666.60WASHINGTON,DCjohn.r.andrus.mil@mail.milJOHNANDRUSPNR Locator:LRHNDYSPEECH OR PRESENTATIONTemporary Duty Travel (Routine)0.00.0
5493N0.0N0.01217.93patrick.a.martinez4.mil@mail.mil63059.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/25/196/27/19NaN5/19/197127TCSG6/3/19JARANDOLPHAFB051919_V02VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN1217.93NNJOHN ANDRUS0.00.0N0.06/25/19387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^19 GPMRC TDYRANDOLPH AFB,TX0.00.06/30/1912.0NNDJ60TCSG0.00.0LVRIJF0.0NaN0.05/22/190.00.02B3KF5 TDNaN6/25/19NaNN*****5797N2B3KF50.0676.004.00.00.00.00.00.01217.931217.93RANDOLPH AFB,TXjohn.r.andrus.mil@mail.milJOHNANDRUSAir Force Medical Corps Development TeamPNR Locator:LVRIJFMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5494N0.0N0.02119.14patrick.a.martinez4.mil@mail.mil63060.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/25/196/27/19NaN5/26/197128TCSG6/3/19JAKELLEYBARRA052719_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN2119.14NYJOHN ANDRUS0.00.0N0.06/25/19387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^19 SG HQ MSPT XKELLEY BARRACKS (STUTTGART),DEU0.00.06/30/1912.0NNDJ60TCSG0.00.02NSZON0.0NaN0.05/31/190.00.02B83TM TDNaN6/25/19NaNN*****5797N2B83TM0.01135.636.00.00.00.00.00.02119.142119.14KELLEY BARRACKS (STUTTGART),DEUjohn.r.andrus.mil@mail.milJOHNANDRUSCOMMAND SURGEON SYNCHRONIZATION CONFERENCEPNR Locator:2NSZONCONFERENCE- NON-TRAININGTemporary Duty Travel (Routine)0.00.0
5495N0.0N0.01304.40Kerry.L.Mosley.MIL@MAIL.mil63061.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/10/196/12/19NaN6/3/197129TCSG6/7/19SBFTBUCHANANI060319_V02VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN1304.40NNSTACEY BRANCH0.00.0N0.06/10/19387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^19 GPMRC TDYFT. BUCHANAN [INCL GSA SVC CTR GUAYNABO],PR0.00.06/30/1912.0NNDJ60TCSG0.00.03OC9FA0.0NaN0.06/6/190.00.02ASROA TDNaN6/7/19NaNN*****1074N2ASROA0.0496.404.00.00.00.00.00.01304.401304.40FT. BUCHANAN [INCL GSA SVC CTR GUAYNABO],PRSTACEY.L.BRANCH.mil@mail.milSTACEYBRANCH2019 TRICARE Latin America and Canada Senior Leaders and Stakeholders Engagement ForumPNR Locator:3OC9FAMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5496Y0.0N0.01493.42patrick.a.martinez4.mil@mail.mil63062.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/5/196/8/19NaN5/27/197130TCSG6/4/19SKKELLEYBARRA052719_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN1493.42NYSYLVIA KIM0.00.0N0.06/5/19387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^19 GPMRC TDYKELLEY BARRACKS (STUTTGART),DEU0.00.06/30/1912.0NNDJ60TCSG0.00.0NaN0.0NaN0.05/31/190.00.02B7MOC TDNaN6/4/19NaNN*****1556N2B7MOC0.00.005.00.00.00.00.00.01493.421493.42KELLEY BARRACKS (STUTTGART),DEUsylvia.kim@us.af.milSYLVIAKIMAFRICOM Surgeon General Synchronization Conference 2019CONFERENCE- NON-TRAININGTemporary Duty Travel (Routine)0.00.0
5497N0.0N0.02582.96patrick.a.martinez4.mil@mail.mil63063.0NaNNaNYesTraveler claimed lodging 2X, once on the per diem screen as it should be and once on the Expense screen. Over paid $644.N8/13/191.0ARCHIVE IMAGE ACCEPT6/21/196/25/19NaN5/19/197131TCSG6/17/19SSNEWORLEANSL051919_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN2582.96NNSTEVEN SAVOY28.01.0N0.06/21/19387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^19 SG HQ MSPT XNEW ORLEANS,LA0.00.06/30/1912.0NNDJ60TCSG644.0644.0NaN1.0NaN0.05/31/191.01.02B0PAL TD7/16/196/20/19NaNN*****7139N2B0PAL0.00.0013.00.00.00.01.00.02582.962582.96NEW ORLEANS,LAsteven.r.savoy3.fm@mail.milStevenSavoySite visits for PM for DSCA & State Gen Pop exerciseMISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0
5498Y0.0N0.01263.76patrick.a.martinez4.mil@mail.mil63064.0NaNNaNNaNNaNNNaN0.0ARCHIVE IMAGE ACCEPT6/21/196/24/19NaN6/10/197132TCSG6/18/19SSSTCROIXVI061019_V01VCHtranscom.scott.tcj8.mbx.dts-rejects@mail.milNaN3221.11NNSTEVEN SAVOY0.00.0N0.06/21/19387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^19 SG HQ MSPT XST. CROIX,VI0.00.06/30/1912.0NNDJ60TCSG0.00.0MC8X580.0NaN0.06/13/190.00.02BH62X TDNaN6/20/19NaNN*****7139N2BH62X1949.00.004.00.00.00.00.00.01263.763221.11ST. CROIX,VIsteven.r.savoy3.fm@mail.milStevenSavoySite visits for DSCA support for 2019 Hurricane SeasonPNR Locator:MC8X58MISSION - OPERATIONALTemporary Duty Travel (Routine)0.00.0